package repository;

import entity.Borrow;

import java.sql.SQLException;
import java.util.List;

public interface BorrowRepository {
    public void insert(Integer bookid,Integer readerid,String borrowtime,String returntime,Integer adminid,Integer statement) throws SQLException;
    public List<Borrow> findAllByReaderId(Integer id,Integer index,Integer limit) throws SQLException;
    public int count(Integer readerId) throws SQLException;
    public List<Borrow> findAllByState(Integer state,Integer index,Integer limit) throws SQLException;
    public int countByState(Integer state) throws SQLException;
    public void handle(Integer borrowId,Integer state,Integer adminId) throws SQLException;
}
